using System;
using System.Data;
using System.Collections.Generic;
namespace eTMS.DAO{
	/********************************BEGIN DanhSachHocBongDAO****************************************/
	///<summary>
	/// <para>Author: Auto generated class by CSharp Code Generator v2.0</para>
	/// <para>Date:23/09/2010 33:09:56</para>
	/// <para>Class Name: DanhSachHocBongDAO</para>
	/// <para>Description: Class access to table DanhSachHocBong in database. Class for coder code here</para>
	///</summary>

	
	public partial class DanhSachHocBongDAO{
        public bool DeleteByCachTinhHocBongHocKyNamHocListSinhVien_ID(int HocKy_ID, int NamHoc_ID, int CachTinhHocBong_ID, List<int> LsSinhVien_ID)
        {
            IDbCommand cmd = this.CreateCommand();
            cmd.CommandText = @"DELETE FROM DanhSachHocBong WHERE CachTinhHocBong_ID=" + CachTinhHocBong_ID.ToString() + " AND HocKy_ID=" + HocKy_ID.ToString() + " AND NamHoc_ID=" + NamHoc_ID.ToString()+" AND SinhVien_ID IN("+string.Join(",",LsSinhVien_ID.ConvertAll<string>(Convert.ToString).ToArray())+")";
            return this.ExcuteNoneQuery(cmd);
        }
	}
	/*****************************************************************************************************/
	/**********************************END DanhSachHocBongDAO*****************************************/
	/*****************************************************************************************************/
}

